﻿DELIMITER //

--
--
DROP PROCEDURE IF EXISTS dsZeusPackageRefill
//

-- HU - Utántöltő lista
-- EN - Packages, palettes for Refill
--
--
CREATE PROCEDURE dsZeusPackageRefill 
  (_AccessToken INTEGER)
BEGIN
  DECLARE _Rows INTEGER;
  DECLARE _UserID INTEGER;
  DECLARE _Lang VARCHAR(10);

  --
  --
  CALL spAccessTokenCheck(_AccessToken, _UserID, _Lang);
  

  -- HU - Visszaadja az adatokat
  -- EN - Get the package details
  --
  SELECT Code, ArticleCode, ArticleName, CAST(Expired as DATE) Expired, LocationCode, Quantity, UnitCode, '' Notes
    FROM ZeusPackage
   WHERE Refill = 'Y' 
   LIMIT 20;
END
//
